Date/Time functions

Date functions allow you to convert numbers to dates (which you can then format to display as you wish) and to convert dates to numbers.

CurrentDate

CurrentTime

CurrentDateTime

Date

Time

DateTime

DateValue

TimeValue

DateTimeValue

DateSerial (year, month, day)

TimeSerial (hour, minute, second)

IsDateTime

IsTime

IsDate

Year (x)

Month (x)

Day (x)

WeekDay

DayOfWeek

Hour (x)

Minute (x)

Second (x)

MonthName

WeekdayName

Timer ( )

DateAdd (intervalType, nIntervals, startDateTime)

DateDiff

DatePart

First Day of Week/Year constants

Additional Date/Time functions

DateTo2000 (Date, Number)

DTSTo2000 (DateString, Number)

DTSToDate (DateTimeString)

DTSToSeconds (DateTimeString)

DTSToTimeString (DateTimeString)



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com